ALTER TABLE XJEquipment ADD UseIn int NOT NULL DEFAULT 0
GO
ALTER TABLE XJEquipmentStock ADD StartOn date,EndOn date
GO
ALTER TABLE XJEquipmentStockOutDetail DROP COLUMN StartOn
GO
ALTER TABLE XJEquipmentStockOutDetail DROP COLUMN EndOn
GO
ALTER TABLE XJEquipmentStock ADD State int NOT NULL DEFAULT 0
GO